<?php

include 'autoload.php';

use Library\MysqliDriver;
use Library\MysqliResult;

// 初始化
$mysqli = new MysqliDriver();
$conf = ['username' => 'root', 'password' => 'root', 'database' => 'pay_system_v5',"host"=>'127.0.0.1'];
$mysqli->connect($conf);


//获取 数据
function getData($mysqli){
	$time = time() - 7*24*60*60;
	$limit = 100;
	$query = $mysqli->query("select pay_bank_account.*,pay_withdraw_money.*,pay_withdraw_money.status from `pay_withdraw_money` left join pay_bank_account  ON pay_bank_account.id = pay_withdraw_money.bank_id where pay_withdraw_money.status  != 0 and pay_withdraw_money.update_time >= {$time} limit {$limit} ");
	return $query->result();
}

getData($mysqli);




